Step-5 Create Database Diagram in ColaberryResortRealtyDM Database 5
Now, we will create Database Diagram in the ColaberryResortRealtyDM Database
Now, Right Click on the Database Diagram within ColaberryResortRealtyDM Database. Ã Click New Database Diagram
Now, Add Table window will open. Choose all the Dimension and Fact tables that we want to add into the Database Diagram à Close the Window
Now, we will
create the relationship between Dim and Fact tables.
For that we will
Select & Drag the Dim_BookingAgenId( Which is a PK in the Dim_BookingAgent
Table) and Drop it on to the Dim_BookingAgentid (which is a FK in the
Fact_Folio Table).
Once you Do that You will see the Following in
your window. Check the relationship and click OK.
Again Click OK
We can see that
relationship has been created
And You will see all the tables with Primarykey Foreignkey relationship among the tables in the diagram. Rearrange & Connect them so, they can fit into the Window
Save the Diagram and you will see the Database diagram created
Please follow the link to see how to create the Database Diagram:
https://www.youtube.com/watch?v=N6PhiiXJMeU
Now, we will create Database Diagram in the ColaberryResortRealtyDM Database
Now, Right Click on the Database Diagram within ColaberryResortRealtyDM Database. Ã Click New Database Diagram
Now, Add Table window will open. Choose all the Dimension and Fact tables that we want to add into the Database Diagram à Close the Window
Now, we will
create the relationship between Dim and Fact tables.
For that we will
Select & Drag the Dim_BookingAgenId( Which is a PK in the Dim_BookingAgent
Table) and Drop it on to the Dim_BookingAgentid (which is a FK in the
Fact_Folio Table).
Once you Do that You will see the Following in
your window. Check the relationship and click OK.
Again Click OK
We can see that
relationship has been created
And You will see all the tables with Primarykey Foreignkey relationship among the tables in the diagram. Rearrange & Connect them so, they can fit into the Window
Save the Diagram and you will see the Database diagram created
Please follow the link to see how to create the Database Diagram:
https://www.youtube.com/watch?v=N6PhiiXJMeU